package com.fjec.user.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.fjec.user.entity.SysUserApp;
import com.fjec.user.entity.UserApp;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

/**
 * <p>
 * 006.用户应用关系表 Mapper 接口
 * </p>
 *
 * @author admin
 * @since 2020-09-04
 */
public interface SysUserAppMapper extends BaseMapper<SysUserApp> {
    @Select("select * from sys_user, sys_user_app where sys_user.id=sys_user_app.UserId and sys_user_app.UserAppId = #{openId}")
    UserApp getUserAppVOByOpenOpenId(@Param("openId") String openId);
}
